﻿CREATE TABLE [dbo].[Bilant] (
    [row]        INT          IDENTITY (1, 1) NOT NULL,
    [nr_rand]    TEXT         NOT NULL,
    [text]       TEXT         NOT NULL,
    [codfix]     INT          NOT NULL,
    [cod]        VARCHAR (10) NOT NULL,
    [coltypei]   CHAR (1)     NOT NULL,
    [soldi]      TEXT         NOT NULL,
    [coltypef]   CHAR (1)     NOT NULL,
    [soldf]      TEXT         NOT NULL,
    [eval]       INT          NOT NULL,
    [CodUnitate] SMALLINT     CONSTRAINT [DF_Bilant_CodUnitate] DEFAULT ((0)) NOT NULL,
    [Boldat]     BIT          CONSTRAINT [DF_Bilant_Boldat] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_Bilant] PRIMARY KEY CLUSTERED ([row] ASC),
    CONSTRAINT [FK_Bilant_Unitati] FOREIGN KEY ([CodUnitate]) REFERENCES [dbo].[Unitati] ([CodUnitate])
);

